<html><head><title>HoneyViz Homepage</title>
<link rel="stylesheet" type="text/css" href="style.css" />
</head>
<body>
<?php
include "validate.php";
include "header.php";
?>
<h2>Administrator Portal</h2>
<?php
$query = "	SELECT topic, comment_text, submit, login.full_name AS name 
		FROM front_page 
		INNER JOIN login ON login.account_id = front_page.account_id
		ORDER BY submit DESC;";

$result = mysql_query($query);
echo "<table>";
while ($row = mysql_fetch_array($result))
{
	echo "<tr><td width = '500'><b>" . $row['topic'] . "</b></td><td width = '200'><b>" . $row['submit'] . "</b></td><td><b>" . $row['name'] . "</b></td></tr>" . 
		"<tr><td colspan = '3'><i>" . $row['comment_text'] . "</i></td></tr><tr height = '50'></tr>";
}
echo "</table>";
?>
</body></html>
